Axis functions
Axis function is:
· Function that is always applied on the whole data set on a single axis (rows or columns),
Once applied, you can add
new elements (levels or members) from already existing dimension
inside axis or elements from new
dimensions to the axis.
Those new elements will be
added, always inside function.
List of functions that are supported in designer:
|
CubePlayer Functions |
MDX Functions used to create CubePlayer
Functions |
|
Best
N |
Equivalent
to TopCount |
|
Best in
Sum |
Equivalent
to TopSum |
|
Best in
Percent |
Equivalent
to TopPercent |
|
Worst
N |
Equivalent
to BottomCount |
|
Worst in
Sum |
Equivalent
to BottomSun |
|
Worst in
Percent |
Equivalent
to BottomPercent |
|
Order |
Equivalent
to Order |
|
Order by
Alphabet |
Combination
of Order function and order conditions |
|
Order by
Hierarchy |
Equivalent
to Hierachize |
|
Filter |
Equivalent
to Filter |
|
Remove
member(s) |
Combination
of Filter (and NOT members …) |
|
First
N |
Equivalent
to Head |
|
Last
N |
Equivalent
to Tail |
|
Contribution |
Special
sintax |
|
For each
from previous dimension |
Equivalent
to Generate |
|
Without
empties |
Equivalent
to NonEmpty |
Whenever axis function is
applied to rows or columns you will be notified:
· If function is not applied title background is white
· If function is applied title
background is red 
Example:
Axis
functions
Axis functions are always applied to entire axis regardless of number of dimension-hierarchies at that axis.
Example
We have level
We will apply TopCount 100 on entire axis
SELECT
NON
EMPTY
TopCount
(
{
[Customer].[hCountry].[
}
,100,
[Measures].[Store Sales]
)
ON
AXIS(0)
FROM
[Sales]
Now when we add another dimension/hierarch, let us say Product Family it will come inside function or better to say
function will be applied after CrossJoin:
SELECT
NON
EMPTY
TopCount
(
CrossJoin
(
{
[Customer].[hCountry].[
},
{
[Product].[hProduct].[Product Family].MEMBERS
}
)
,100, [Measures].[Store Sales]
)
ON
AXIS(0)
FROM
[Sales]
The same will be when we add third dimension:
SELECT
NON
EMPTY
TopCount
(
CrossJoin
(
CrossJoin
(
{
[Customer].[hCountry].[
},
{
[Product].[hProduct].[Product Family].MEMBERS
}
),
{
[Store].[hStoreType].[Store Type].MEMBERS
}
)
,100, [Measures].[Store Sales]
)
ON
AXIS(0)
FROM
[Sales]